﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_DeletePersonLocations')
	BEGIN
		DROP  Procedure  esf_sso.P_DeletePersonLocations
	END

GO

CREATE Procedure esf_sso.P_DeletePersonLocations
	@pPersonID BIGINT
AS

	DELETE FROM [esf_sso].[Person_Location]
	WHERE
		PersonID = @pPersonID 
           
GO 